﻿<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="DPMStats.aspx.cs" Inherits="NCC_SOP.DPMStats" %>

<asp:Content ID="HeaderContent" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .RadListBox1
        {
            width: 222px;
        }
    </style>
</asp:Content>
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
    <h2 style="color:red">DPM Stats</h2>
    <h2>&nbsp;&nbsp;&nbsp; Statistics for DPM Department</h2>

    <fieldset>
        <div class="statsType">
            <telerik:RadComboBox ID="RadComboBox1" runat="server" Width="160px" Label="Statistic Type: "
            AutoPostBack="true" EmptyMessage="- Select a Statistic Type -" DataSourceID="SqlDataSource1"
            DataValueField="TableAttributeValue" DataTextField="TableAttributeValue" OnSelectedIndexChanged="RadComboBox1_SelectedIndexChanged"
            Skin="Metro">
            </telerik:RadComboBox>
            <telerik:RadComboBox ID="RadComboBox2" runat="server" Width="160px" Label="Aggregate Type: "
                AutoPostBack="true" EmptyMessage="- Select an Aggregate Type -" 
                OnSelectedIndexChanged="RadComboBox2_SelectedIndexChanged" Visible = "false"
                Skin="Metro">
            </telerik:RadComboBox>
            <h2></h2>
            <telerik:RadComboBox ID="RadComboBox3" runat="server" Width="160px" Label="Admission Type: "
                AutoPostBack="true" EmptyMessage="- Select an Admission Type -" 
                OnSelectedIndexChanged="RadComboBox3_SelectedIndexChanged" Visible = "false"
                Skin="Metro">
            </telerik:RadComboBox>
        </div>


        <h2></h2>

        <telerik:RadListBox runat="server" ID="RadListBox1" CssClass="RadListBox1" 
            Width="500px" Height="320px"
                    Skin="Metro" Visible="false">
        </telerik:RadListBox>


        <p class="buttons">
            <asp:Button ID="Button1" runat="server" Text="Get Report" OnClick="Button1_Click" />
        </p>

    </fieldset>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:localSQLString %>"
            ProviderName="System.Data.SqlClient" 
            SelectCommand="select distinct TableAttributeValue from MetadataDPMTableAttributeValues where TableAttributeId = 1"
            ></asp:SqlDataSource>

    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:localSQLString %>"
            ProviderName="System.Data.SqlClient" 
            SelectCommand="select distinct TableAttributeValue from MetadataDPMTableAttributeValues where TableAttributeId = 2"
            ></asp:SqlDataSource>

</asp:Content>
